package com.example.authority.controller;

import cn.dev33.satoken.stp.StpUtil;
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.read.listener.PageReadListener;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.authority.common.Result;

import com.example.authority.entity.Order;
import com.example.authority.service.OrderService;
import com.example.authority.service.UserService;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.tags.Tag;
import jakarta.annotation.Resource;
import jakarta.servlet.http.HttpServletResponse;
import org.apache.commons.math3.analysis.function.Add;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;
import java.net.URLEncoder;
import java.util.Arrays;
import java.util.List;


import com.example.authority.service.AddressService;
import com.example.authority.entity.Address;


/**
 * @program: authority-hm-0.0.1
 * @ClassName:AddressController
 * @description: AddressController前端控制器
 * @author:dyy
 * @Version 3.0
 **/
@Tag(name = "地址列表 前端控制器")
@RestController
@RequestMapping("/address")
public class AddressController {

    @Resource
    private AddressService addressService;
    @Resource
    private UserService userService;
    @Resource
    private OrderService orderService;

    /**
     * 新增
     *
     * @param address
     * @return
     */
    @Operation(summary = "新增")
    @PostMapping
    public Result save(@RequestBody Address address) {
        address.setUsername(userService.getUserInfo().getUsername());
//        如果没有记录则设置为默认地址
        if (addressService.list(new LambdaQueryWrapper<Address>().eq(Address::getUsername, userService.getUserInfo())).size() == 0) {
            address.setIsDefault(1);
        }
        address.setIsDefault(0);

        return Result.success(addressService.save(address));
    }

    /**
     * 修改
     *
     * @param address
     * @return
     */
    @Operation(summary = "修改")
    @PutMapping("/{id}")
    public Result update(@PathVariable Long id, @RequestBody Address address) {
        if (address.getIsDefault() == 1) {
            addressService.list(new LambdaQueryWrapper<Address>().eq(Address::getUsername, userService.getUserInfo().getUsername())).forEach(address1 -> {
                address1.setIsDefault(0);
                addressService.updateById(address1);
            });
        }
        return Result.success(addressService.updateById(address));
    }

    /**
     * 查询所有Address
     *
     * @return
     */
    @Operation(summary = "查询所有Address")
    @GetMapping
    public Result findAll() {

        return Result.success(addressService.list(StpUtil.hasRole("user") ? new LambdaQueryWrapper<Address>().eq(Address::getUsername, userService.getUserInfo().getUsername()) : new LambdaQueryWrapper<>()));
    }

    /**
     * 获取单个
     *
     * @param id
     * @return
     */
    @Operation(summary = "获取单个")
    @GetMapping("/{id}")
    public Result findOne(@PathVariable Integer id) {
        return Result.success(addressService.getById(id));
    }

    /**
     * 分页显示
     *
     * @param name
     * @param pageNum
     * @param pageSize
     * @return
     */
    @Operation(summary = "分页显示")
    @GetMapping("/page")
    public Result findPage(
            @RequestParam(defaultValue = "") String name,
            @RequestParam(defaultValue = "1") Integer pageNum,
            @RequestParam(defaultValue = "10") Integer pageSize) {
        QueryWrapper<Address> queryWrapper = new QueryWrapper<>();
        if (!"".equals(name)) {
            queryWrapper.like("name", name);

        }

            queryWrapper.eq("username", userService.getUserInfo().getUsername());

        queryWrapper.orderByDesc("id");
        return Result.success(addressService.page(new Page<>(pageNum, pageSize), queryWrapper));
    }

    /**
     * 单个删除
     *
     * @param id
     * @return
     */
    @Operation(summary = "单个删除")
    @DeleteMapping("/{id}")
    public Result delete(@PathVariable Integer id) {
        if (orderService.list(new LambdaQueryWrapper<Order>().eq(Order::getAid,id)).size()>0){
            throw new RuntimeException("存在关联订单记录无法删除！");
        }
        return Result.success(addressService.removeById(id));
    }

    /**
     * 批量删除
     *
     * @param ids
     * @return
     */
    @Operation(summary = "批量删除")
    @DeleteMapping("/batch/{ids}")
    @Transactional
    public Result deleteByIds(@PathVariable String[] ids) {
        return Result.success(addressService.removeByIds(Arrays.asList(ids)));
    }

    /**
     * 批量导出
     * 使用的技术为alibaba下面的easyexcel
     * 写数据
     *
     * @param ids
     * @return
     */
    @Operation(summary = "批量导出")
    @GetMapping("/batch/export/{ids}")
    public void exportByIds(@PathVariable String[] ids, HttpServletResponse response) throws IOException {

        List<Address> list = addressService.listByIds(Arrays.asList(ids));
        // 这里注意 有同学反应使用swagger 会导致各种问题，请直接用浏览器或者用postman
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setCharacterEncoding("utf-8");
        // 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系
        String fileName = URLEncoder.encode("address导出数据", "UTF-8").replaceAll("\\+", "%20");
        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
        EasyExcel.write(response.getOutputStream(), Address.class).sheet("sheel1").doWrite(list);

    }

    /**
     * 批量导入
     * 使用的技术为alibaba下面的easyexcel
     * 读数据
     *
     * @param
     */
    @Operation(summary = "批量导入")
    @PostMapping("/batch/upload")
    public Result writeExcel(MultipartFile file) throws IOException {
        EasyExcel.read(file.getInputStream(), Address.class, new PageReadListener<Address>(dataList -> {
            dataList.forEach(entity -> addressService.save(entity.toBuilder().id(null).build()));
        })).sheet().doRead();
        return Result.success();
    }

}